forum

home / developersection / forums / how to edit update in gridview in c#.net

Ask Question

how to edit update in gridview in c#.net

Anonymous User 1908 18-Nov-2015
 I want to edit update data in gridview  how to do this please help me.
.net c#  asp.net 
Updated on 18-Nov-2015
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

18-Nov-2015 
   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" OnRowCommand="GridView1_RowCommand1" >
        <Columns>
            <asp:TemplateField HeaderText="Emp_ID"  >
                <ItemTemplate>
                    <%#Eval("Emp_ID") %> <asp:HiddenField ID="EmpID" runat="server" Value='<%#Eval("Emp_ID") %>' />
                </ItemTemplate>
                <ControlStyle Width="100px"></ControlStyle>
                <HeaderStyle Width="100px" />
                <ItemStyle HorizontalAlign="Center" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Emp_Name"  >
                <ItemTemplate>
                    <%#Eval("Emp_Name") %>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="txtname" runat="server" Text='<%# Bind("Emp_Name") %>'></asp:TextBox>
                </EditItemTemplate>
                <ControlStyle Width="300px"></ControlStyle>
                <HeaderStyle Width="200px" />
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Emp_Sal" >
                <ItemTemplate>
                    <%#Eval("Emp_Sal") %>
                </ItemTemplate>
                 <EditItemTemplate>
                    <asp:TextBox ID="txtsal" runat="server" Text='<%# Bind("Emp_Sal") %>'></asp:TextBox>
                </EditItemTemplate>
                <ControlStyle Width="200px"></ControlStyle>
                <HeaderStyle Width="200px" />
            </asp:TemplateField>
                <asp:TemplateField HeaderText="Emp_Sal" >
                <ItemTemplate>
                    <asp:Button ID="btnedit" runat="server" Text="Edit" CommandName="Change"  CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />
                </ItemTemplate>
                 <EditItemTemplate>
                     <asp:Button ID="btnupdate" runat="server" Text="Update" CommandName="Save"  CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />
                </EditItemTemplate>
                <ControlStyle Width="200px"></ControlStyle>
                <HeaderStyle Width="200px" />
            </asp:TemplateField>
        </Columns>
        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
        <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
        <RowStyle BackColor="White" ForeColor="#330099" />
        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
        <SortedAscendingCellStyle BackColor="#FEFCEB" />
        <SortedAscendingHeaderStyle BackColor="#AF0101" />
        <SortedDescendingCellStyle BackColor="#F6F0C0" />
        <SortedDescendingHeaderStyle BackColor="#7E0000" />
    </asp:GridView>
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


namespace Forumasp


{


    public partial class GridviewSorting : System.Web.UI.Page


    {


        protected void Page_Load(object sender, EventArgs e)


        {


            if (!IsPostBack)


            {


                GridView1.DataSource = GetRecord(); //set DataSource GridView


                GridView1.DataBind(); //binding GridView


            }


        }



        public DataTable GetRecord()


        {


            DataTable dt = new DataTable();


            string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string


            SqlConnection con = new SqlConnection(constr);


            con.Open();


            SqlCommand com = new SqlCommand("select *from Employee", con); // table name 


            SqlDataAdapter da = new SqlDataAdapter(com);


            DataSet ds = new DataSet();


            da.Fill(ds);


            dt = ds.Tables[0];


            return dt;


        }



        protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e)


        {


            int index = Convert.ToInt32(e.CommandArgument.ToString());


            if (e.CommandName == "Change")


            {


                GridView1.EditIndex = index;


                GridView1.DataSource = GetRecord(); //set DataSource GridView


                GridView1.DataBind(); //binding GridView


            }


            else if (e.CommandName == "Save")


            {


                HiddenField EmpID = GridView1.Rows[index].FindControl("EmpID") as HiddenField;


                TextBox txtname = GridView1.Rows[index].FindControl("txtname") as TextBox;


                TextBox txtsal = GridView1.Rows[index].FindControl("txtsal") as TextBox;


                string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string


                SqlConnection con = new SqlConnection(constr);


                con.Open();


                string sqlstr = "update Employee set Emp_Name='" + txtname.Text + "', Emp_Sal='" + txtsal.Text + "' where Emp_ID=" + EmpID.Value + "";


                SqlCommand cmd = new SqlCommand(sqlstr, con); // table name 


                cmd.ExecuteNonQuery();


                con.Close();


                GridView1.EditIndex = -1;


                GridView1.DataSource = GetRecord(); //set DataSource GridView


                GridView1.DataBind(); //binding GridView


            }


        }



    }


}
how to edit update in gridview in c#.net
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy